SqlConnectionDataProvider Constructor(SqlConnection,ReadOnlyCollection<String>)

In This Topic

Initializes the data provider to access all elements available from the connection that belong to the passed schemas.

Syntax

Visual Basic
C#
C++/CLI

'Declaration
 
Public Function New( _
   ByVal connection As SqlConnection, _
   ByVal tableSchemas As ReadOnlyCollection(Of String) _
)

public SqlConnectionDataProvider( 
   SqlConnection connection,
   ReadOnlyCollection<string> tableSchemas
)

public:
SqlConnectionDataProvider( 
   SqlConnection^ connection,
   ReadOnlyCollection<String^>^ tableSchemas
)

Parameters

connection: The connection to use.
tableSchemas: The list of allowed table schemas.

Example

SqlConnection conn = new SqlConnection(Properties.Settings.Default.ConnectionString); 
List<string> schemas = new List<string>();
schemas.Add("Sales");
schemas.Add("HumanResources");
SqlConnectionDataProvider provider = new SqlConnectionDataProvider(conn, schemas.AsReadOnly());
provider.PrefixTableNameWithSchema = true;
LL.DataSource = provider;
LL.Design();

VB.NET

Dim conn As New SqlConnection(Properties.Settings.[Default].ConnectionString)
Dim schemas As New List(Of String)()
schemas.Add("Sales")
schemas.Add("HumanResources")
Dim provider As New SqlConnectionDataProvider(conn, schemas.AsReadOnly())
provider.PrefixTableNameWithSchema = True
LL.DataSource = provider
LL.Design()

Requirements

Reference

SqlConnectionDataProvider Class
SqlConnectionDataProvider Members
Overload List

Send Feedback